package com.bm.server.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.bm.common.dto.UsroomDto;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * YoungMan, may the force be with you.
 *
 * @Author: 吃个小布丁吧
 * @Date: 2022/07/18/19:57
 */
public interface UsroomDtoDao {
    @Select("SELECT s.sname,s.simg, u.uname,u.giftname,u.roomid,u.uimg,u.gimg FROM t_suroom AS s,t_uroom AS u WHERE s.sid = u.uid")
    List<UsroomDto> selectAll();
}
